﻿
CREATE proc [dbo].[GetCustomerSource]
@CustomerSourceID	int = null
as
begin

	select	cs.CustomerSourceID,
			cs.CustomerSourceShort,
			cs.CustomerSourceLong
	from	dbo.domCustomerSource cs
	where	cs.CustomerSourceID = @CustomerSourceID
				or @CustomerSourceID is null
	order by cs.CustomerSourceShort

end


GO
GRANT EXECUTE
    ON OBJECT::[dbo].[GetCustomerSource] TO PUBLIC
    AS [dbo];

